package com.czc.cca.ddl;

import org.zoomdev.zoom.dao.ddl.SqlType;
import org.zoomdev.zoom.dao.ddl._DDL_Column;
import org.zoomdev.zoom.dao.ddl._DDL_Primary;
import org.zoomdev.zoom.dao.ddl._DDL_Table;
import org.zoomdev.zoom.dao.driver.mysql.MysqlDriver;

@_DDL_Table(name = "aqb_card", simpleName = "", engine = MysqlDriver.InnoDB, comment = "卡片AQB")
public class _DDL_AqbCard {

    @_DDL_Column(name = "USER_ID", type = SqlType.INT, nullable = false, comment = "用户ID")
    private Integer userId;

    @_DDL_Column(name = "BASE_STATUS", type = SqlType.INT, nullable = false, comment = "基础状态，0：无效、1：有效")
    private Integer baseStatus;

    @_DDL_Column(name = "BASE_ACC_TYPE", type = SqlType.INT, nullable = false, comment = "基础账号类型，1：平安、2：内部户")
    private Integer baseAccType;

    @_DDL_Column(name = "CARD_NO", type = SqlType.VARCHAR, size = 30, nullable = false, comment = "易通卡卡号")
    private String cardNo;

    @_DDL_Column(name = "CARD_REMARK", type = SqlType.VARCHAR, size = 50, comment = "卡片备注")
    private String cardRemark;

    @_DDL_Column(name = "CARD_STATUS", type = SqlType.VARCHAR, size = 50, nullable = false, comment = "卡片状态")
    private String cardStatus;

    @_DDL_Column(name = "BIND_ACCT_NO", type = SqlType.VARCHAR, size = 30, comment = "一类银行卡")
    private String bindAcctNo;

    @_DDL_Column(name = "SIGN_ACCT_NO", type = SqlType.VARCHAR, size = 50, nullable = false, comment = "三类户")
    private String signAcctNo;

    @_DDL_Column(name = "OPEN_SIGN_ID", type = SqlType.VARCHAR, size = 30, comment = "签约协议号")
    private String openSignId;

    @_DDL_Primary()
    @_DDL_Column(name = "AQB_MER_ORDER_NO", type = SqlType.VARCHAR, size = 50, nullable = false, comment = "开AQB商户号")
    private String aqbMerOrderNo;

    @_DDL_Column(name = "AQB_ACCT_NO", type = SqlType.VARCHAR, size = 50, comment = "AQB账号")
    private String aqbAcctNo;

    @_DDL_Column(name = "AQB_STATUS", type = SqlType.VARCHAR, size = 65, comment = "AQB账号状态")
    private String aqbStatus;

    @_DDL_Column(name = "AQB_BALANCE", type = SqlType.VARCHAR, size = 20, comment = "AQB账号余额")
    private String aqbBalance;

    @_DDL_Column(name = "ARREARAGE_AMT", type = SqlType.VARCHAR, size = 20, nullable = false, comment = "欠费金额")
    private String arrearageAmt;

    @_DDL_Column(name = "REGISTE_TIME", type = SqlType.VARCHAR, size = 19, comment = "注册时间")
    private String registeTime;

    @_DDL_Column(name = "DESTROY_TIME", type = SqlType.VARCHAR, size = 19, comment = "注销时间")
    private String destroyTime;

    @_DDL_Column(name = "UPDATE_TIME", type = SqlType.VARCHAR, size = 19, comment = "更新时间")
    private String updateTime;

    @_DDL_Column(name = "RECHARGE_MER_ORDER_NO", type = SqlType.VARCHAR, size = 50, comment = "充值商户号")
    private String rechargeMerOrderNo;

    @_DDL_Column(name = "RECHARGE_TRANS_STATUS", type = SqlType.VARCHAR, size = 50, comment = "充值交易状态")
    private String rechargeTransStatus;

    @_DDL_Column(name = "WITHDRAW_MER_ORDER_NO", type = SqlType.VARCHAR, size = 50, comment = "提现商户号")
    private String withdrawMerOrderNo;

    @_DDL_Column(name = "WITHDRAW_TRANS_STATUS", type = SqlType.VARCHAR, size = 50, comment = "提现交易状态")
    private String withdrawTransStatus;

    @_DDL_Column(name = "OPEN_PAYMENT_SSN", type = SqlType.VARCHAR, size = 50, comment = "开通ECA支付订单号")
    private String openPaymentSsn;

    @_DDL_Column(name = "OPEN_ORDER_STATUS", type = SqlType.VARCHAR, size = 3, comment = "开通ECA卟噔订单状态")
    private String openOrderStatus;

    @_DDL_Column(name = "CLOSE_PAYMENT_SSN", type = SqlType.VARCHAR, size = 50, comment = "开关闭ECA支付订单号")
    private String closePaymentSsn;

    @_DDL_Column(name = "CLOSE_ORDER_STATUS", type = SqlType.VARCHAR, size = 3, comment = "关闭ECA卟噔订单状态")
    private String closeOrderStatus;

    @_DDL_Column(name = "UNBIND_TRADE_ID", type = SqlType.VARCHAR, size = 50, comment = "解绑交易ID")
    private String unbindTradeId;

    @_DDL_Column(name = "BIND_ACCT_NO_CIPHERTEXT", type = SqlType.VARCHAR, size = 100, comment = "一类银行卡密文")
    private String bindAcctNoCiphertext;

}
